SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for location
-- ----------------------------
DROP TABLE IF EXISTS `location`;
CREATE TABLE `location` (
  `id` int NOT NULL AUTO_INCREMENT,
  `lat` double(20,10) NOT NULL,
  `lng` double(20,10) NOT NULL,
  `time` bigint DEFAULT NULL,
  `uid` bigint DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=340 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of location
-- ----------------------------
BEGIN;
INSERT INTO `location` VALUES (1, 31.0000000000, 104.0000000000, 1592286107, 5);
INSERT INTO `location` VALUES (3, 31.0000000000, 104.0000000000, 1592286147, 5);
INSERT INTO `location` VALUES (4, 30.6700000000, 104.0700000000, 1592286167, 8);
INSERT INTO `location` VALUES (5, 31.0000000000, 104.0000000000, 1592286187, 5);
INSERT INTO `location` VALUES (7, 31.0000000000, 104.0000000000, 1592286227, 5);
INSERT INTO `location` VALUES (8, 31.0000000000, 104.0000000000, 1592286247, 5);
INSERT INTO `location` VALUES (10, 31.0000000000, 104.0000000000, 1592286287, 5);
INSERT INTO `location` VALUES (12, 30.6700000000, 104.0700000000, 1592286327, 8);
INSERT INTO `location` VALUES (13, 31.0000000000, 104.0000000000, 1592286347, 5);
INSERT INTO `location` VALUES (14, 31.0000000000, 104.0000000000, 1592286367, 5);
INSERT INTO `location` VALUES (16, 31.0000000000, 104.0000000000, 1592286407, 5);
INSERT INTO `location` VALUES (17, 30.6700000000, 104.0700000000, 1592286427, 8);
INSERT INTO `location` VALUES (18, 31.0000000000, 104.0000000000, 1592286447, 5);
INSERT INTO `location` VALUES (19, 30.6700000000, 104.0700000000, 1592286467, 8);
INSERT INTO `location` VALUES (20, 31.0000000000, 104.0000000000, 1592286487, 5);
INSERT INTO `location` VALUES (21, 31.0000000000, 104.0000000000, 1592286507, 5);
INSERT INTO `location` VALUES (118, 30.5313470000, 104.0570590000, 1592367785, 7);
INSERT INTO `location` VALUES (119, 30.5428470000, 104.0570490000, 1592367785, 7);
INSERT INTO `location` VALUES (120, 30.5438470000, 104.0570390000, 1592367785, 7);
INSERT INTO `location` VALUES (121, 30.5448470000, 104.0570290000, 1592367785, 7);
INSERT INTO `location` VALUES (122, 30.5458470000, 104.0570490000, 1592367785, 7);
INSERT INTO `location` VALUES (123, 30.5448470000, 104.0570590000, 1592367785, 7);
INSERT INTO `location` VALUES (124, 30.5438470000, 104.0570690000, 1592367785, 7);
INSERT INTO `location` VALUES (125, 30.5428470000, 104.0570790000, 1592367785, 7);
INSERT INTO `location` VALUES (126, 30.5313470000, 104.1705900000, 1592367863, 7);
INSERT INTO `location` VALUES (127, 30.4428470000, 104.2570490000, 1592367863, 7);
INSERT INTO `location` VALUES (128, 30.5438470000, 104.3570390000, 1592367863, 7);
INSERT INTO `location` VALUES (129, 30.6448470000, 104.4570290000, 1592367863, 7);
INSERT INTO `location` VALUES (130, 30.7458470000, 104.5570490000, 1592367863, 7);
INSERT INTO `location` VALUES (131, 30.5448470000, 104.6570590000, 1592367863, 7);
INSERT INTO `location` VALUES (132, 30.5438470000, 104.4570690000, 1592367863, 7);
INSERT INTO `location` VALUES (133, 30.5428470000, 104.3570790000, 1592367863, 7);
INSERT INTO `location` VALUES (134, 30.2313470000, 104.2705900000, 1592368489, 5);
INSERT INTO `location` VALUES (135, 30.2428470000, 104.3570490000, 1592368489, 5);
INSERT INTO `location` VALUES (136, 30.3438470000, 104.4570390000, 1592368489, 5);
INSERT INTO `location` VALUES (137, 30.5448470000, 104.3570290000, 1592368489, 5);
INSERT INTO `location` VALUES (138, 30.7458470000, 104.6570490000, 1592368489, 5);
INSERT INTO `location` VALUES (139, 30.5448470000, 104.8570590000, 1592368489, 5);
INSERT INTO `location` VALUES (140, 30.7438470000, 104.9570690000, 1592368489, 5);
INSERT INTO `location` VALUES (141, 30.8428470000, 104.3570790000, 1592368489, 5);
INSERT INTO `location` VALUES (142, 31.2313470000, 104.1705900000, 1592368522, 8);
INSERT INTO `location` VALUES (143, 31.2428470000, 104.1570490000, 1592368522, 8);
INSERT INTO `location` VALUES (144, 31.3438470000, 104.2570390000, 1592368522, 8);
INSERT INTO `location` VALUES (145, 31.5448470000, 104.3570290000, 1592368522, 8);
INSERT INTO `location` VALUES (146, 31.7458470000, 104.6570490000, 1592368522, 8);
INSERT INTO `location` VALUES (147, 31.5448470000, 104.8570590000, 1592368522, 8);
INSERT INTO `location` VALUES (148, 32.7438470000, 104.9570690000, 1592368522, 8);
INSERT INTO `location` VALUES (149, 32.8428470000, 104.3570790000, 1592368522, 8);
INSERT INTO `location` VALUES (150, 30.5498270000, 104.0561250000, 1592981874, 7);
INSERT INTO `location` VALUES (151, 30.5498220000, 104.0561190000, 1592981880, 7);
INSERT INTO `location` VALUES (152, 30.5498220000, 104.0561190000, 1592981885, 7);
INSERT INTO `location` VALUES (153, 30.5498220000, 104.0561190000, 1592981890, 7);
INSERT INTO `location` VALUES (154, 30.5498220000, 104.0561190000, 1592981895, 7);
INSERT INTO `location` VALUES (155, 30.5498220000, 104.0561190000, 1592981900, 7);
INSERT INTO `location` VALUES (156, 30.5498220000, 104.0561190000, 1592981905, 7);
INSERT INTO `location` VALUES (157, 30.5498220000, 104.0561190000, 1592981910, 7);
INSERT INTO `location` VALUES (158, 30.5498220000, 104.0561190000, 1592981915, 7);
INSERT INTO `location` VALUES (159, 30.5504080000, 104.0559410000, 1592981920, 7);
INSERT INTO `location` VALUES (160, 30.5504080000, 104.0559410000, 1592981925, 7);
INSERT INTO `location` VALUES (161, 30.5504080000, 104.0559410000, 1592981930, 7);
INSERT INTO `location` VALUES (162, 30.5504080000, 104.0559410000, 1592981935, 7);
INSERT INTO `location` VALUES (163, 30.5504080000, 104.0559410000, 1592981940, 7);
INSERT INTO `location` VALUES (164, 30.5504080000, 104.0559410000, 1592981945, 7);
INSERT INTO `location` VALUES (165, 30.5504080000, 104.0559410000, 1592981950, 7);
INSERT INTO `location` VALUES (166, 30.5504080000, 104.0559410000, 1592981955, 7);
INSERT INTO `location` VALUES (167, 30.5504080000, 104.0559410000, 1592981960, 7);
INSERT INTO `location` VALUES (168, 30.5504080000, 104.0559410000, 1592981965, 7);
INSERT INTO `location` VALUES (169, 30.5504080000, 104.0559410000, 1592981970, 7);
INSERT INTO `location` VALUES (170, 30.5504080000, 104.0559410000, 1592981975, 7);
INSERT INTO `location` VALUES (171, 30.5504080000, 104.0559410000, 1592981980, 7);
INSERT INTO `location` VALUES (172, 30.5504080000, 104.0559410000, 1592981985, 7);
INSERT INTO `location` VALUES (173, 30.5504080000, 104.0559410000, 1592981990, 7);
INSERT INTO `location` VALUES (174, 30.5504080000, 104.0559410000, 1592981995, 7);
INSERT INTO `location` VALUES (175, 30.5504080000, 104.0559410000, 1592982000, 7);
INSERT INTO `location` VALUES (176, 30.5504080000, 104.0559410000, 1592982005, 7);
INSERT INTO `location` VALUES (177, 30.5504080000, 104.0559410000, 1592982010, 7);
INSERT INTO `location` VALUES (178, 30.5504080000, 104.0559410000, 1592982015, 7);
INSERT INTO `location` VALUES (179, 30.5504080000, 104.0559410000, 1592982020, 7);
INSERT INTO `location` VALUES (180, 30.5504080000, 104.0559410000, 1592982025, 7);
INSERT INTO `location` VALUES (181, 30.5504080000, 104.0559410000, 1592982030, 7);
INSERT INTO `location` VALUES (182, 30.5504080000, 104.0559410000, 1592982035, 7);
INSERT INTO `location` VALUES (183, 30.5504080000, 104.0559410000, 1592982040, 13);
INSERT INTO `location` VALUES (184, 30.5504080000, 104.0559410000, 1592982045, 13);
INSERT INTO `location` VALUES (185, 30.5504080000, 104.0559410000, 1592982050, 13);
INSERT INTO `location` VALUES (186, 30.5504080000, 104.0559410000, 1592982055, 13);
INSERT INTO `location` VALUES (187, 30.5504080000, 104.0559410000, 1592982060, 13);
INSERT INTO `location` VALUES (188, 30.5504080000, 104.0559410000, 1592982065, 13);
INSERT INTO `location` VALUES (189, 30.5504080000, 104.0559410000, 1592982070, 13);
INSERT INTO `location` VALUES (190, 30.5504080000, 104.0559410000, 1592982075, 13);
INSERT INTO `location` VALUES (191, 30.5504080000, 104.0559410000, 1592982080, 13);
INSERT INTO `location` VALUES (192, 30.5504080000, 104.0559410000, 1592982085, 13);
INSERT INTO `location` VALUES (193, 30.5504080000, 104.0559410000, 1592982090, 13);
INSERT INTO `location` VALUES (194, 30.5504080000, 104.0559410000, 1592982095, 13);
INSERT INTO `location` VALUES (195, 30.5504080000, 104.0559410000, 1592982100, 13);
INSERT INTO `location` VALUES (196, 30.5504080000, 104.0559410000, 1592982105, 13);
INSERT INTO `location` VALUES (197, 30.5504080000, 104.0559410000, 1592982110, 13);
INSERT INTO `location` VALUES (198, 30.5504080000, 104.0559410000, 1592982115, 13);
INSERT INTO `location` VALUES (199, 30.5504080000, 104.0559410000, 1592982120, 13);
INSERT INTO `location` VALUES (200, 30.5504080000, 104.0559410000, 1592982125, 13);
INSERT INTO `location` VALUES (201, 30.5504080000, 104.0559410000, 1592982130, 13);
INSERT INTO `location` VALUES (202, 30.5504080000, 104.0559410000, 1592982135, 13);
INSERT INTO `location` VALUES (203, 30.5504080000, 104.0559410000, 1592982140, 13);
INSERT INTO `location` VALUES (204, 30.5504080000, 104.0559410000, 1592982145, 13);
INSERT INTO `location` VALUES (205, 30.5504080000, 104.0559410000, 1592982150, 13);
INSERT INTO `location` VALUES (206, 30.5504080000, 104.0559410000, 1592982155, 13);
INSERT INTO `location` VALUES (207, 30.5504080000, 104.0559410000, 1592982160, 13);
INSERT INTO `location` VALUES (208, 30.5503690000, 104.0559830000, 1592982177, 13);
INSERT INTO `location` VALUES (209, 30.5503690000, 104.0559830000, 1592982184, 13);
INSERT INTO `location` VALUES (210, 30.5503690000, 104.0559830000, 1592982188, 7);
INSERT INTO `location` VALUES (211, 30.5503690000, 104.0559830000, 1592982193, 7);
INSERT INTO `location` VALUES (212, 30.5503690000, 104.0559830000, 1592982198, 7);
INSERT INTO `location` VALUES (213, 30.5503690000, 104.0559830000, 1592982203, 7);
INSERT INTO `location` VALUES (214, 30.5503690000, 104.0559830000, 1592982223, 7);
INSERT INTO `location` VALUES (215, 30.5504100000, 104.0558870000, 1592982229, 7);
INSERT INTO `location` VALUES (216, 30.5504100000, 104.0558870000, 1592982233, 7);
INSERT INTO `location` VALUES (217, 30.5504100000, 104.0558870000, 1592982238, 7);
INSERT INTO `location` VALUES (218, 30.5504100000, 104.0558870000, 1592982243, 7);
INSERT INTO `location` VALUES (219, 30.5504100000, 104.0558870000, 1592982248, 7);
INSERT INTO `location` VALUES (220, 30.5504100000, 104.0558870000, 1592982253, 7);
INSERT INTO `location` VALUES (221, 30.5504100000, 104.0558870000, 1592982258, 7);
INSERT INTO `location` VALUES (222, 30.5504100000, 104.0558870000, 1592982263, 7);
INSERT INTO `location` VALUES (223, 30.5504100000, 104.0558870000, 1592982268, 7);
INSERT INTO `location` VALUES (224, 30.5504100000, 104.0558870000, 1592982273, 7);
INSERT INTO `location` VALUES (225, 30.5504100000, 104.0558870000, 1592982278, 7);
INSERT INTO `location` VALUES (226, 30.5504100000, 104.0558870000, 1592982283, 7);
INSERT INTO `location` VALUES (227, 30.5504100000, 104.0558870000, 1592982288, 7);
INSERT INTO `location` VALUES (228, 30.5504100000, 104.0558870000, 1592982293, 7);
INSERT INTO `location` VALUES (229, 30.5504100000, 104.0558870000, 1592982298, 7);
INSERT INTO `location` VALUES (230, 30.5504100000, 104.0558870000, 1592982303, 7);
INSERT INTO `location` VALUES (231, 30.5504100000, 104.0558870000, 1592982308, 7);
INSERT INTO `location` VALUES (232, 30.5504100000, 104.0558870000, 1592982313, 7);
INSERT INTO `location` VALUES (233, 30.5504100000, 104.0558870000, 1592982318, 7);
INSERT INTO `location` VALUES (234, 30.5504100000, 104.0558870000, 1592982323, 7);
INSERT INTO `location` VALUES (235, 30.5504100000, 104.0558870000, 1592982328, 7);
INSERT INTO `location` VALUES (236, 30.5504100000, 104.0558870000, 1592982333, 7);
INSERT INTO `location` VALUES (237, 30.5504100000, 104.0558870000, 1592982338, 7);
INSERT INTO `location` VALUES (238, 30.5504100000, 104.0558870000, 1592982343, 7);
INSERT INTO `location` VALUES (239, 30.5504100000, 104.0558870000, 1592982348, 7);
INSERT INTO `location` VALUES (240, 30.5504100000, 104.0558870000, 1592982354, 7);
INSERT INTO `location` VALUES (241, 30.5504100000, 104.0558870000, 1592982358, 7);
INSERT INTO `location` VALUES (242, 30.5504100000, 104.0558870000, 1592982363, 7);
INSERT INTO `location` VALUES (243, 30.5504100000, 104.0558870000, 1592982368, 7);
INSERT INTO `location` VALUES (244, 30.5504100000, 104.0558870000, 1592982373, 7);
INSERT INTO `location` VALUES (245, 30.5504100000, 104.0558870000, 1592982378, 7);
INSERT INTO `location` VALUES (246, 30.5504100000, 104.0558870000, 1592982383, 7);
INSERT INTO `location` VALUES (247, 30.5504100000, 104.0558870000, 1592982388, 7);
INSERT INTO `location` VALUES (248, 30.5504100000, 104.0558870000, 1592982393, 7);
INSERT INTO `location` VALUES (249, 30.5504100000, 104.0558870000, 1592982398, 7);
INSERT INTO `location` VALUES (250, 30.5504100000, 104.0558870000, 1592982403, 7);
INSERT INTO `location` VALUES (251, 30.5504100000, 104.0558870000, 1592982408, 7);
INSERT INTO `location` VALUES (252, 30.5504100000, 104.0558870000, 1592982413, 7);
INSERT INTO `location` VALUES (253, 30.5504100000, 104.0558870000, 1592982418, 7);
INSERT INTO `location` VALUES (254, 30.5504100000, 104.0558870000, 1592982423, 7);
INSERT INTO `location` VALUES (255, 30.5504100000, 104.0558870000, 1592982428, 7);
INSERT INTO `location` VALUES (256, 30.5504100000, 104.0558870000, 1592982433, 7);
INSERT INTO `location` VALUES (257, 30.5504100000, 104.0558870000, 1592982438, 7);
INSERT INTO `location` VALUES (258, 30.5504100000, 104.0558870000, 1592982443, 7);
INSERT INTO `location` VALUES (259, 30.5504100000, 104.0558870000, 1592982448, 7);
INSERT INTO `location` VALUES (260, 30.5504100000, 104.0558870000, 1592982453, 7);
INSERT INTO `location` VALUES (261, 30.5462020000, 104.0692030000, 1592997188, 8);
INSERT INTO `location` VALUES (262, 30.5462020000, 104.0692030000, 1592997193, 8);
INSERT INTO `location` VALUES (263, 30.5462020000, 104.0692030000, 1592997198, 8);
INSERT INTO `location` VALUES (264, 30.5462020000, 104.0692030000, 1592997204, 8);
INSERT INTO `location` VALUES (265, 30.5462020000, 104.0692030000, 1592997224, 8);
INSERT INTO `location` VALUES (266, 30.5462020000, 104.0692030000, 1592997228, 8);
INSERT INTO `location` VALUES (267, 30.5462020000, 104.0692030000, 1592997233, 8);
INSERT INTO `location` VALUES (268, 30.5462020000, 104.0692030000, 1592997238, 8);
INSERT INTO `location` VALUES (269, 30.5462020000, 104.0692030000, 1592997243, 8);
INSERT INTO `location` VALUES (270, 30.5462020000, 104.0692030000, 1592997248, 8);
INSERT INTO `location` VALUES (271, 30.5462020000, 104.0692030000, 1592997253, 8);
INSERT INTO `location` VALUES (272, 30.5462020000, 104.0692030000, 1592997258, 8);
INSERT INTO `location` VALUES (273, 30.5462020000, 104.0692030000, 1592997263, 8);
INSERT INTO `location` VALUES (274, 30.5462020000, 104.0692030000, 1592997268, 8);
INSERT INTO `location` VALUES (275, 30.5462020000, 104.0692030000, 1592997273, 8);
INSERT INTO `location` VALUES (276, 30.5462020000, 104.0692030000, 1592997278, 8);
INSERT INTO `location` VALUES (277, 30.5504220000, 104.0558440000, 1593412064, 7);
INSERT INTO `location` VALUES (278, 30.5504290000, 104.0558660000, 1593412070, 7);
INSERT INTO `location` VALUES (279, 30.5504290000, 104.0558660000, 1593412075, 7);
INSERT INTO `location` VALUES (280, 30.5504290000, 104.0558660000, 1593412080, 7);
INSERT INTO `location` VALUES (281, 30.5504290000, 104.0558660000, 1593412085, 7);
INSERT INTO `location` VALUES (282, 30.5504290000, 104.0558660000, 1593412090, 7);
INSERT INTO `location` VALUES (283, 30.5504290000, 104.0558660000, 1593412095, 7);
INSERT INTO `location` VALUES (284, 30.5504290000, 104.0558660000, 1593412100, 7);
INSERT INTO `location` VALUES (285, 30.5504290000, 104.0558660000, 1593412105, 7);
INSERT INTO `location` VALUES (286, 30.5504290000, 104.0558660000, 1593412110, 7);
INSERT INTO `location` VALUES (287, 30.5504290000, 104.0558660000, 1593412115, 7);
INSERT INTO `location` VALUES (288, 30.5504290000, 104.0558660000, 1593412120, 7);
INSERT INTO `location` VALUES (289, 30.5504290000, 104.0558660000, 1593412125, 7);
INSERT INTO `location` VALUES (290, 30.5504290000, 104.0558660000, 1593412130, 7);
INSERT INTO `location` VALUES (291, 30.5504290000, 104.0558660000, 1593412135, 7);
INSERT INTO `location` VALUES (292, 30.5504290000, 104.0558660000, 1593412140, 7);
INSERT INTO `location` VALUES (293, 30.5504290000, 104.0558660000, 1593412145, 7);
INSERT INTO `location` VALUES (294, 30.5504290000, 104.0558660000, 1593412150, 7);
INSERT INTO `location` VALUES (295, 30.5504290000, 104.0558660000, 1593412155, 7);
INSERT INTO `location` VALUES (296, 30.5504290000, 104.0558660000, 1593412160, 7);
INSERT INTO `location` VALUES (297, 30.5504290000, 104.0558660000, 1593412165, 7);
INSERT INTO `location` VALUES (298, 30.5504290000, 104.0558660000, 1593412170, 7);
INSERT INTO `location` VALUES (299, 30.5504290000, 104.0558660000, 1593412175, 7);
INSERT INTO `location` VALUES (300, 30.5504290000, 104.0558660000, 1593412180, 7);
INSERT INTO `location` VALUES (301, 30.5504290000, 104.0558660000, 1593412185, 7);
INSERT INTO `location` VALUES (302, 30.5504290000, 104.0558660000, 1593412190, 7);
INSERT INTO `location` VALUES (303, 30.5504290000, 104.0558660000, 1593412195, 7);
INSERT INTO `location` VALUES (304, 30.5504290000, 104.0558660000, 1593412200, 7);
INSERT INTO `location` VALUES (305, 30.5504290000, 104.0558660000, 1593412205, 7);
INSERT INTO `location` VALUES (306, 30.5504290000, 104.0558660000, 1593412210, 7);
INSERT INTO `location` VALUES (307, 30.5504290000, 104.0558660000, 1593412215, 7);
INSERT INTO `location` VALUES (308, 30.5504290000, 104.0558660000, 1593412220, 7);
INSERT INTO `location` VALUES (309, 30.5504290000, 104.0558660000, 1593412225, 7);
INSERT INTO `location` VALUES (310, 30.5504290000, 104.0558660000, 1593412230, 7);
INSERT INTO `location` VALUES (311, 30.5504290000, 104.0558660000, 1593412235, 7);
INSERT INTO `location` VALUES (312, 30.5504290000, 104.0558660000, 1593412240, 7);
INSERT INTO `location` VALUES (313, 30.5504290000, 104.0558660000, 1593412245, 7);
INSERT INTO `location` VALUES (314, 30.5504290000, 104.0558660000, 1593412250, 7);
INSERT INTO `location` VALUES (315, 30.5504290000, 104.0558660000, 1593412255, 7);
INSERT INTO `location` VALUES (316, 30.5504290000, 104.0558660000, 1593412260, 7);
INSERT INTO `location` VALUES (317, 30.5504290000, 104.0558660000, 1593412265, 7);
INSERT INTO `location` VALUES (318, 30.5504290000, 104.0558660000, 1593412270, 7);
INSERT INTO `location` VALUES (319, 30.5504290000, 104.0558660000, 1593412275, 7);
INSERT INTO `location` VALUES (320, 30.5504290000, 104.0558660000, 1593412280, 7);
INSERT INTO `location` VALUES (321, 30.5504290000, 104.0558660000, 1593412285, 7);
INSERT INTO `location` VALUES (322, 30.5504290000, 104.0558660000, 1593412290, 7);
INSERT INTO `location` VALUES (323, 30.5504290000, 104.0558660000, 1593412295, 7);
INSERT INTO `location` VALUES (324, 30.5504290000, 104.0558660000, 1593412300, 7);
INSERT INTO `location` VALUES (325, 30.5504290000, 104.0558660000, 1593412305, 7);
INSERT INTO `location` VALUES (326, 30.5504290000, 104.0558660000, 1593412310, 7);
INSERT INTO `location` VALUES (327, 30.5504290000, 104.0558660000, 1593412315, 7);
INSERT INTO `location` VALUES (328, 30.5498270000, 104.0561240000, 1593412320, 7);
INSERT INTO `location` VALUES (329, 30.5498270000, 104.0561240000, 1593412325, 7);
INSERT INTO `location` VALUES (330, 30.5498270000, 104.0561240000, 1593412330, 7);
INSERT INTO `location` VALUES (331, 30.5498270000, 104.0561240000, 1593412335, 7);
INSERT INTO `location` VALUES (332, 30.5498270000, 104.0561240000, 1593412340, 7);
INSERT INTO `location` VALUES (333, 30.5498270000, 104.0561240000, 1593412345, 7);
INSERT INTO `location` VALUES (334, 30.5504050000, 104.0557080000, 1593412350, 7);
INSERT INTO `location` VALUES (335, 30.5504050000, 104.0557080000, 1593412355, 7);
INSERT INTO `location` VALUES (336, 30.5504050000, 104.0557080000, 1593412360, 7);
INSERT INTO `location` VALUES (337, 30.5504050000, 104.0557080000, 1593412365, 7);
INSERT INTO `location` VALUES (338, 30.5504050000, 104.0557080000, 1593412370, 7);
INSERT INTO `location` VALUES (339, 30.5504050000, 104.0557080000, 1593412375, 7);
COMMIT;

-- ----------------------------
-- Table structure for setting
-- ----------------------------
DROP TABLE IF EXISTS `setting`;
CREATE TABLE `setting` (
  `id` int NOT NULL AUTO_INCREMENT,
  `uploadi_interval` bigint DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of setting
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `uid` bigint NOT NULL AUTO_INCREMENT,
  `username` varchar(40) NOT NULL,
  `password` varchar(40) NOT NULL,
  `token` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '',
  `name` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '',
  `create_time` bigint NOT NULL,
  `update_time` bigint DEFAULT NULL,
  `mobile` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '',
  `gender` tinyint(1) DEFAULT '0' COMMENT '0:男 1:女',
  `user_role` tinyint(3) unsigned zerofill DEFAULT '000',
  `avatar` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '',
  `last_login_time` bigint DEFAULT NULL,
  PRIMARY KEY (`uid`),
  UNIQUE KEY `username` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of user
-- ----------------------------
BEGIN;
INSERT INTO `user` VALUES (5, 'jafir1', '', 'eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJsb2dpbk5hbWUiOiJqYWZpcjEiLCJleHAiOjE1OTU0MTAwNTQsInVzZXJJZCI6IjUifQ.3rkm3ZesGC0sDFW4QvWwicYvPUdf6Jssfpd71nCQkhk', '垃圾', 1591260914901, 1592992140719, '13982004324', 0, 000, 'http://47.108.59.73:9090/res/88059A5489A45387693EF7FE74D57AED.jpg', 1592807361268);
INSERT INTO `user` VALUES (7, 'jafir', 'cc', 'eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJsb2dpbk5hbWUiOiJqYWZpciIsImV4cCI6MTU5NjAwNDA2NCwidXNlcklkIjoiNyJ9.3HQtopUF3ayWyUYiOaFeys1cEeARbYsBQ4AeyIwDSas', '韩建飞1', 1591263522452, 1592996364291, '13982004324', 0, 000, 'http://47.108.59.73:9090/res/合成.jpg', 1593412064403);
INSERT INTO `user` VALUES (8, 'wanglei', '123', 'eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJsb2dpbk5hbWUiOiJqYWZpcjExMSIsImV4cCI6MTU5NTU4OTIxOSwidXNlcklkIjoiOCJ9.poO0QA2r6cglNWG0NFA-SD7aYCyKTAvIFxehemyAdjY', '王雷儿子呢', 1591263705525, 1593411994801, '13982004324', 0, 000, 'http://47.108.59.73:9090/res/75A08841E1686D65C4BD74D973159A9A.png', 1592997219726);
INSERT INTO `user` VALUES (9, 'han', 'han', NULL, 'han', 1592822994600, NULL, NULL, NULL, NULL, 'http://127.0.0.1:9090/res/D732E60B0C67092E8518BE59E75BC97F.jpg', NULL);
INSERT INTO `user` VALUES (10, 'hhh', 'hhh', NULL, 'hhhh', 1592827443499, NULL, '139999', NULL, NULL, 'http://127.0.0.1:9090/res/C34D15D2B1E94BB8BB3FA7133A3E2E70.jpg', NULL);
INSERT INTO `user` VALUES (11, 'h', 'h', NULL, 'h', 1592827560438, NULL, 'h', NULL, NULL, 'http://127.0.0.1:9090/res/HXFUTEFNTTRM3]$_}2N)L@Q.jpg', NULL);
INSERT INTO `user` VALUES (12, 'jj', 'jj', NULL, '1111111111', 1592878620216, 1593319530152, '13982004324', NULL, NULL, 'http://127.0.0.1:9090/res/10276266.jpeg', NULL);
INSERT INTO `user` VALUES (13, 'kk', 'kk', 'eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJsb2dpbk5hbWUiOiJrayIsImV4cCI6MTU5NTU3NDEwMSwidXNlcklkIjoiMTMifQ.4BrPRdKi9X9oD0GRnf9EMvNInLuVnZLHUGUnsKI1QPM', 'kk', 1592878916033, 1593319640271, '13982004324', NULL, NULL, 'http://47.108.59.73:9090/res/10276266.jpeg', 1592982101495);
INSERT INTO `user` VALUES (14, 'll', 'll', NULL, 'aa', 1592879243810, 1592879601776, '13982000411', NULL, NULL, '/img/logo.82b9c7a5.png', NULL);
INSERT INTO `user` VALUES (15, 'aa', 'aa', NULL, 'aa', 1592879370351, NULL, '13982004324', NULL, NULL, '/img/logo.82b9c7a5.png', NULL);
INSERT INTO `user` VALUES (16, 'ddd', 'ddd', NULL, 'ddd', 1592980606696, NULL, '13982002222', NULL, NULL, '/img/logo.82b9c7a5.png', NULL);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
